package com.dhecp.project.hr.controller;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.apache.shiro.authz.annotation.Logical;
import org.apache.shiro.authz.annotation.RequiresPermissions;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.servlet.ModelAndView;

import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.dhecp.common.annotation.Log;
import com.dhecp.common.annotation.RepeatSubmit;
import com.dhecp.common.core.domain.AjaxResult;
import com.dhecp.common.core.page.TableDataInfo;
import com.dhecp.common.enums.BusinessType;
import com.dhecp.common.utils.TypeUtils;
import com.dhecp.core.constant.ModuleTable;
import com.dhecp.core.utils.ExportExcelUtils;
import com.dhecp.core.utils.ReadExcel;
import com.dhecp.framework.web.service.BaseInfoSimpleService;
import com.dhecp.project.base.domain.BaseInfo;
import com.dhecp.project.common.controller.BaseModuleController;
import com.dhecp.project.hr.domain.OperateCompanyApply;
import com.dhecp.project.hr.domain.OperateCompanyRatio;
import com.dhecp.project.hr.domain.OperateCompanyRoute;
import com.dhecp.project.hr.service.OperateCompanyApplyService;
import com.dhecp.project.hr.service.OperateCompanyRouteService;
import com.dhecp.project.system.domain.SysDictionaryForExport;
import com.dhecp.project.system.domain.SysDictionaryForPageField;
import com.dhecp.project.system.service.SysDictionaryForFieldService;

/**
 * @program: kjecp
 * @description: 运营公司路径表
 * @author: hlf
 * @create: 2022-10-20 14:46
 */
@Controller
@RequestMapping("/hr/operatecompanyroute")
public class OperateCompanyRouteController extends BaseModuleController {

    private String prefix = "hr/operatecompanyroute";
    private String moduleTable = ModuleTable.OPERATE_COMPANY_ROUTE;
    private String moduleTable2 = ModuleTable.OPERATE_COMPANY_RATIO;

    @Autowired
    private OperateCompanyRouteService operateCompanyRouteService;
    @Autowired
    private OperateCompanyApplyService operateCompanyApplyService;

    @Autowired
    private SysDictionaryForFieldService dictionaryForFieldService;


    @Autowired
    private BaseInfoSimpleService baseInfoSimpleService;

    /**
     * 打开查询列表页
     * @param params
     * @return
     * @author DH-Xxj
     */
    @RequiresPermissions("hr:operatecompanyroute:view")
    @GetMapping()
    public ModelAndView listPage(@RequestParam Map<String, Object> params){
        params.put("moduleTable", moduleTable);
        params.put("entity", new OperateCompanyRoute()); //生成表格gridColumns对应的实体，用于获取实体属性生成表格字段
        params.put("prefix",prefix + "/operatecompanyroute"); //页面路径
        params.put("toolBarWidth", 200);
        ModelAndView mv = this.openListPage(params);
        mv.addObject("hr", "operatecompanyroute");
//        OperateCompanyRatio ratio = new OperateCompanyRatio();
//        ratio = businessService.ratioTop1(params);
//        mv.addObject("ratio", ratio);
        return mv;
    }

    /**
     * 打开比例编辑页面
     * @param params
     * @return
     * @author DH-Xxj
     */
    @RequiresPermissions("hr:operatecompanyroute:view")
    @GetMapping("/ratioEdit")
    public ModelAndView ratioEdit(@RequestParam Map<String, Object> params){
        params.put("moduleTable", moduleTable2);
        params.put("entity", new OperateCompanyRatio()); //用于获取实体属性名取代对应字典字段名，解决大小写敏感问题
        ModelAndView mv = this.getModelAndView();
        AjaxResult ajaxResult = new AjaxResult();
        List<SysDictionaryForPageField> dicFieldsList = new ArrayList<SysDictionaryForPageField>(); //字段字典
        List<Object> fieldsList = new ArrayList<Object>(); 			//生成控件的字段和属性
        List<Object> fieldsHiddenList = new ArrayList<Object>(); 	//隐藏的字段和属性
        Map<String, Object> dictionaryForFieldMap = new HashMap<String, Object>();
        OperateCompanyRatio infoItem = new OperateCompanyRatio();
        try{
            dictionaryForFieldMap = dictionaryForFieldService.queryFieldAttributesMap(params);
            infoItem = operateCompanyRouteService.findByRatioGuid(params);
            if (dictionaryForFieldMap.isEmpty()){
                ajaxResult = AjaxResult.error("未获取到字段属性。");
            }else{
                ajaxResult = AjaxResult.success("数据获取成功。");
            }
            params.put("getFieldAttributesType", "pagenotingrid"); 	//非表格字段
            dicFieldsList = dictionaryForFieldService.queryFieldAttributesList(params);
            if (dicFieldsList.isEmpty()){
                ajaxResult = AjaxResult.error("未获取到字段属性。");
            }else{
                for (SysDictionaryForPageField dicFields : dicFieldsList){
                    Map<String, Object> fieldsListMap = TypeUtils.entityToMap(dicFields);

                    if (infoItem!=null){
                        Map<String, Object> infoData = TypeUtils.entityToMap(infoItem);
                        fieldsListMap.put("fieldContent", infoData.get(fieldsListMap.get("fields")));
                    }else{
                        fieldsListMap.put("fieldContent", "");

                    }
                    if (fieldsListMap.get("fieldFrontType") == null){
                        fieldsListMap.put("fieldFrontType", "t_text");
                    }

                    //如果有下拉控件，则根据配置获取对应下拉待选内容
                    List<BaseInfo> dropdownList = new ArrayList<BaseInfo>();
                    String fieldFrontType = dicFields.getFieldFrontType();
                    String fieldSearchType = dicFields.getFieldSearchType();
                    String fieldFrontSave = dicFields.getFieldFrontSave();
                    String fieldFrontShow = dicFields.getFieldFrontShow();
                    if (fieldFrontType != null && fieldFrontType.toLowerCase().startsWith("t_dropdown")){
                        if (fieldSearchType != null && !"".equals(fieldSearchType)){
                            if (fieldFrontSave == null || "".equals(fieldFrontSave)){
                                fieldFrontSave = "vid";
                            }
                            if (fieldFrontShow == null || "".equals(fieldFrontShow)){
                                fieldFrontShow = "vname";
                            }
                            dropdownList = baseInfoSimpleService.getDropdownData(fieldSearchType,fieldFrontSave,fieldFrontShow);
                        }
                    }
                    fieldsListMap.put("dropdownList", dropdownList);

                    if ((Integer)fieldsListMap.get("fieldFrontTop") == 1){	//显示的字段
                        fieldsList.add(TypeUtils.mapToJson(fieldsListMap));
                    }else {	//隐藏的字段
                        fieldsHiddenList.add(TypeUtils.mapToJson(fieldsListMap));
                    }
                }
            }
        }
        catch(Exception e){
            ajaxResult = AjaxResult.error(this.getExceptionMessage(e));
        }
        mv.addObject("fields", TypeUtils.mapToJson(dictionaryForFieldMap)); //各字段及属性
        mv.addObject("fieldsList", fieldsList);				//显示的字段
        mv.addObject("fieldsHiddenList", fieldsHiddenList);	//隐藏的字段
        mv.addObject("operatecompanyratio", infoItem);	//字段
        mv.addObject("ajaxResult", ajaxResult);
        mv.setViewName(prefix + "/operatecompanyroute_ratio");
        return mv;
    }

    /**
     * 打开制单页
     * @param nid 必要参数：单据编码（新增时传默认值 0 ，修改、查看时传单据实际值）
     * @return
     * @author DH-Xxj
     */
    @RequiresPermissions("hr:operatecompanyroute:view")
    @GetMapping("/edit")
    public ModelAndView editPage(@RequestParam Map<String, Object> params){
        params.put("moduleTable", moduleTable);
        params.put("entity", new OperateCompanyRoute()); //用于获取实体属性名取代对应字典字段名，解决大小写敏感问题
        ModelAndView mv = this.getModelAndView();
        AjaxResult ajaxResult = new AjaxResult();
        List<SysDictionaryForPageField> dicFieldsList = new ArrayList<SysDictionaryForPageField>(); //字段字典
        List<Object> fieldsList = new ArrayList<Object>(); 			//生成控件的字段和属性
        List<Object> fieldsHiddenList = new ArrayList<Object>(); 	//隐藏的字段和属性
        Map<String, Object> dictionaryForFieldMap = new HashMap<String, Object>();
        OperateCompanyRoute infoItem = new OperateCompanyRoute();
        try{
            dictionaryForFieldMap = dictionaryForFieldService.queryFieldAttributesMap(params);
            infoItem = operateCompanyRouteService.findByGuid(params);
            if (dictionaryForFieldMap.isEmpty()){
                ajaxResult = AjaxResult.error("未获取到字段属性。");
            }else{
                ajaxResult = AjaxResult.success("数据获取成功。");
            }
            params.put("getFieldAttributesType", "pagenotingrid"); 	//非表格字段
            dicFieldsList = dictionaryForFieldService.queryFieldAttributesList(params);
            if (dicFieldsList.isEmpty()){
                ajaxResult = AjaxResult.error("未获取到字段属性。");
            }else{
                for (SysDictionaryForPageField dicFields : dicFieldsList){
                    Map<String, Object> fieldsListMap = TypeUtils.entityToMap(dicFields);

                    if (infoItem!=null){
                        Map<String, Object> infoData = TypeUtils.entityToMap(infoItem);
                        fieldsListMap.put("fieldContent", infoData.get(fieldsListMap.get("fields")));
                    }else{
                        fieldsListMap.put("fieldContent", "");

                    }
                    if (fieldsListMap.get("fieldFrontType") == null){
                        fieldsListMap.put("fieldFrontType", "t_text");
                    }

                    //如果有下拉控件，则根据配置获取对应下拉待选内容
                    List<BaseInfo> dropdownList = new ArrayList<BaseInfo>();
                    String fieldFrontType = dicFields.getFieldFrontType();
                    String fieldSearchType = dicFields.getFieldSearchType();
                    String fieldFrontSave = dicFields.getFieldFrontSave();
                    String fieldFrontShow = dicFields.getFieldFrontShow();
                    if (fieldFrontType != null && fieldFrontType.toLowerCase().startsWith("t_dropdown")){
                        if (fieldSearchType != null && !"".equals(fieldSearchType)){
                            if (fieldFrontSave == null || "".equals(fieldFrontSave)){
                                fieldFrontSave = "vid";
                            }
                            if (fieldFrontShow == null || "".equals(fieldFrontShow)){
                                fieldFrontShow = "vname";
                            }
                            dropdownList = baseInfoSimpleService.getDropdownData(fieldSearchType,fieldFrontSave,fieldFrontShow);
                        }
                    }
                    fieldsListMap.put("dropdownList", dropdownList);

                    if ((Integer)fieldsListMap.get("fieldFrontTop") == 1){	//显示的字段
                        fieldsList.add(TypeUtils.mapToJson(fieldsListMap));
                    }else {	//隐藏的字段
                        fieldsHiddenList.add(TypeUtils.mapToJson(fieldsListMap));
                    }
                }
            }
        }
        catch(Exception e){
            ajaxResult = AjaxResult.error(this.getExceptionMessage(e));
        }
        mv.addObject("fields", TypeUtils.mapToJson(dictionaryForFieldMap)); //各字段及属性
        mv.addObject("fieldsList", fieldsList);				//显示的字段
        mv.addObject("fieldsHiddenList", fieldsHiddenList);	//隐藏的字段
        mv.addObject("operatecompanyroute", infoItem);	//字段
        mv.addObject("ajaxResult", ajaxResult);
        mv.setViewName(prefix + "/operatecompanyroute_edit");
        return mv;

    }

    /**
     * 查询页 列表数据
     * @param params
     * @return
     * @author DH-Xxj
     */
    @RequiresPermissions("hr:operatecompanyroute:list")
    @GetMapping("/list")
    @ResponseBody
    public TableDataInfo list(@RequestParam Map<String, Object> params){
        params.put("moduleTable", moduleTable);
        List<OperateCompanyRoute> list = new ArrayList<OperateCompanyRoute>();
        try {
            list = operateCompanyRouteService.queryList(params);
        } catch (Exception e) {
            e.printStackTrace();
            return getDataTable(this.getExceptionMessage(e).toString());
        }
        return getDataTable(list);
    }


    /**
     * 保存数据
     * @param infoMap 必要参数：非网格字段（包括头部、底部所有显示和隐藏的字段）
     * @param infoItems 必要参数：对应实体类的json格式字符串
     * @return
     * @author DH-Xxj
     */
    @RequiresPermissions(value={"hr:operatecompanyroute:add","hr:operatecompanyroute:edit","hr:operatecompanyroute:delete"},logical= Logical.OR)
    @Log(title = "运营比例", businessType = BusinessType.UPDATE)
    @PostMapping("/ratioSave")
    @ResponseBody
    @RepeatSubmit
    public AjaxResult ratioSave(@RequestParam Map<String, Object> params){
        params.put("moduleTable", moduleTable);
        AjaxResult ajaxResult = new AjaxResult();
        try {
            ajaxResult= operateCompanyRouteService.ratioSave(params);
        }catch (Exception e) {
            ajaxResult = AjaxResult.error(this.getExceptionMessage(e));
        }
        return ajaxResult;
    }


    /**
     * 保存数据
     * @param infoMap 必要参数：非网格字段（包括头部、底部所有显示和隐藏的字段）
     * @param infoItems 必要参数：对应实体类的json格式字符串
     * @return
     * @author DH-Xxj
     */
    @RequiresPermissions(value={"hr:operatecompanyroute:add","hr:operatecompanyroute:edit","hr:operatecompanyroute:delete"},logical= Logical.OR)
    @Log(title = "运营架构", businessType = BusinessType.UPDATE)
    @PostMapping("/editpost")
    @ResponseBody
    @RepeatSubmit
    public AjaxResult editSave(@RequestParam Map<String, Object> params){
        params.put("moduleTable", moduleTable);
        AjaxResult ajaxResult = new AjaxResult();
        try {
            ajaxResult= operateCompanyRouteService.saveData(params);
        }catch (Exception e) {
            ajaxResult = AjaxResult.error(this.getExceptionMessage(e));
        }
        return ajaxResult;
    }


    /**
     * 批量设置公司负债额度
     */
    @GetMapping("/editpostLocal")
    @ResponseBody
    public AjaxResult editpostLocal(){

    	AjaxResult ajaxResult = new AjaxResult();  

        try {
	    	List<List<String>> rows = ReadExcel.getRowsByFile("d:\\Users\\Administrator\\Desktop\\导入ERP\\公司信息.xlsx", 2);
	        for (int i = 1; i < rows.size(); i++) {

	        	List<String> row = rows.get(i);
	        	Map<String, Object> params = new HashMap<String, Object>();
	            params.put("moduleTable", moduleTable);
	            
	            OperateCompanyApply operateCompanyApply = operateCompanyApplyService.findByShortName(row.get(0));
	            if (operateCompanyApply == null) {
					continue;
				}
	        	
	        	JSONArray infoItemsJA = new JSONArray();
	        	JSONObject JO = new JSONObject();
	        	JO.put("guid", "");
	        	JO.put("vGsBm", operateCompanyApply.getvGsBm());
	        	JO.put("vJcBl", "0");
	        	JO.put("vYyBl", "0");
	        	JO.put("vTsBl", row.get(3));
	        	infoItemsJA.add(JO);
	        	params.put("infoItems", infoItemsJA.toJSONString());
	            ajaxResult= operateCompanyRouteService.saveData(params);
	        }
    	
        }catch (Exception e) {
            ajaxResult = AjaxResult.error(this.getExceptionMessage(e));
        }
        return ajaxResult;
    }

    /**
     * 数据导出Excel
     * @param params
     * @return
     * @throws Exception
     * @author DH-Xxj
     */
    @RequiresPermissions("hr:operatecompanyroute:export")
    @Log(title = "运营架构数据导出", businessType = BusinessType.EXPORT)
    @GetMapping("/export")
    @ResponseBody
    @RepeatSubmit
    public AjaxResult export(@RequestParam Map<String, Object> params) throws Exception {
        params.put("moduleTable", moduleTable);
        params.put("entity", new OperateCompanyRoute());

        List<OperateCompanyRoute> list = operateCompanyRouteService.queryList(params);

        params.put("getFieldAttributesType", "export");
        List<SysDictionaryForExport> fieldList = dictionaryForFieldService.queryExportFieldList(params);
        ExportExcelUtils<OperateCompanyRoute> util = new ExportExcelUtils<OperateCompanyRoute>(moduleTable,new OperateCompanyRoute());
        return util.exportExcel(list, fieldList, "运营架构数据", "export");
    }
}